Tabela PhTenderOfferItem

Definicja tabeli PhTenderOfferItem

Name

PhTenderOfferItem

Code

PhTenderOfferItem

Comment

Elementy ofert/umów w ramach przetargów


Lista kolumn tabeli PhTenderOfferItem

Name

Code

TenderOfferItemID

TenderOfferItemID

TenderOfferID

TenderOfferID

TenderListItemID

TenderListItemID

ItemNo

ItemNo

PriceGross

PriceGross

PriceNet

PriceNet

Quantity

Quantity

ValueGross

ValueGross

ValidityPeriodUnitID

ValidityPeriodUnitID

ValidityPeriodQuantity

ValidityPeriodQuantity

TendOffItemTypeID

TendOffItemTypeID


Kolumna TenderOfferItemID tabeli PhTenderOfferItem

Definicja kolumny TenderOfferItemID tabeli PhTenderOfferItem

Name

TenderOfferItemID

Code

TenderOfferItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID elementu umowy


Kolumna TenderOfferID tabeli PhTenderOfferItem

Definicja kolumny TenderOfferID tabeli PhTenderOfferItem

Name

TenderOfferID

Code

TenderOfferID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TenderListItemID tabeli PhTenderOfferItem

Definicja kolumny TenderListItemID tabeli PhTenderOfferItem

Name

TenderListItemID

Code

TenderListItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ItemNo tabeli PhTenderOfferItem

Definicja kolumny ItemNo tabeli PhTenderOfferItem

Name

ItemNo

Code

ItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba porzadkowa


Kolumna PriceGross tabeli PhTenderOfferItem

Definicja kolumny PriceGross tabeli PhTenderOfferItem

Name

PriceGross

Code

PriceGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena brutto


Kolumna PriceNet tabeli PhTenderOfferItem

Definicja kolumny PriceNet tabeli PhTenderOfferItem

Name

PriceNet

Code

PriceNet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena netto


Kolumna Quantity tabeli PhTenderOfferItem

Definicja kolumny Quantity tabeli PhTenderOfferItem

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc


Kolumna ValueGross tabeli PhTenderOfferItem

Definicja kolumny ValueGross tabeli PhTenderOfferItem

Name

ValueGross

Code

ValueGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Wartosc sumarycznie


Kolumna ValidityPeriodUnitID tabeli PhTenderOfferItem

Definicja kolumny ValidityPeriodUnitID tabeli PhTenderOfferItem

Name

ValidityPeriodUnitID

Code

ValidityPeriodUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Minimalny okres waznosci - jednostka


Kolumna ValidityPeriodQuantity tabeli PhTenderOfferItem

Definicja kolumny ValidityPeriodQuantity tabeli PhTenderOfferItem

Name

ValidityPeriodQuantity

Code

ValidityPeriodQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

Minimalny okres waznosci - ilosc


Kolumna TendOffItemTypeID tabeli PhTenderOfferItem

Definicja kolumny TendOffItemTypeID tabeli PhTenderOfferItem

Name

TendOffItemTypeID

Code

TendOffItemTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do tabeli PhTendOffItemType


Lista kluczy tabeli PhTenderOfferItem

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhTenderOfferItem

Definicja klucza Key_1 tabeli PhTenderOfferItem

Name

Key_1

Code

Key_1

Primary

Yes

Comment